DBC-Zorgproducten per jaar, specialisme, diagnose

Dataset statistics

Number of variables	14
Number of observations	318926
Missing cells	48866
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.1 MiB
Average record size in memory	112.0 B

Variable types

Categorical	4
DateTime	1
Numeric	9

Alerts

`VERSIE` has constant value ""	Constant
`DATUM_BESTAND` has constant value ""	Constant
`PEILDATUM` has constant value ""	Constant
`TYPERENDE_DIAGNOSE_CD` has a high cardinality: 1897 distinct values	High cardinality
`BEHANDELEND_SPECIALISME_CD` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`AANTAL_PAT_PER_ZPD` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_ZPD`	High correlation
`AANTAL_SUBTRAJECT_PER_ZPD` is highly overall correlated with `AANTAL_PAT_PER_ZPD`	High correlation
`AANTAL_PAT_PER_DIAG` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_DIAG`	High correlation
`AANTAL_SUBTRAJECT_PER_DIAG` is highly overall correlated with `AANTAL_PAT_PER_DIAG`	High correlation
`AANTAL_PAT_PER_SPC` is highly overall correlated with `BEHANDELEND_SPECIALISME_CD` and 1 other fields	High correlation
`AANTAL_SUBTRAJECT_PER_SPC` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`GEMIDDELDE_VERKOOPPRIJS` has 48866 (15.3%) missing values	Missing
`AANTAL_SUBTRAJECT_PER_ZPD` is highly skewed (γ1 = 21.29093219)	Skewed

Reproduction

Analysis started	2023-01-30 17:17:53.384956
Analysis finished	2023-01-30 17:18:13.405267
Duration	20.02 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

VERSIE
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

1.0	318926

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	956778
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	318926	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	318926	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	318926	33.3%
.	318926	33.3%
0	318926	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	637852	66.7%
Other Punctuation	318926	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	318926	50.0%
0	318926	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	318926	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	956778	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	318926	33.3%
.	318926	33.3%
0	318926	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	956778	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	318926	33.3%
.	318926	33.3%
0	318926	33.3%

DATUM_BESTAND
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

2023-01-06	318926

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3189260
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-01-06
2nd row	2023-01-06
3rd row	2023-01-06
4th row	2023-01-06
5th row	2023-01-06

Common Values

Value	Count	Frequency (%)
2023-01-06	318926	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-01-06	318926	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	956778	30.0%
2	637852	20.0%
-	637852	20.0%
3	318926	10.0%
1	318926	10.0%
6	318926	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2551408	80.0%
Dash Punctuation	637852	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	956778	37.5%
2	637852	25.0%
3	318926	12.5%
1	318926	12.5%
6	318926	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	637852	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3189260	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	956778	30.0%
2	637852	20.0%
-	637852	20.0%
3	318926	10.0%
1	318926	10.0%
6	318926	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3189260	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	956778	30.0%
2	637852	20.0%
-	637852	20.0%
3	318926	10.0%
1	318926	10.0%
6	318926	10.0%

PEILDATUM
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

2023-01-01	318926

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3189260
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-01-01
2nd row	2023-01-01
3rd row	2023-01-01
4th row	2023-01-01
5th row	2023-01-01

Common Values

Value	Count	Frequency (%)
2023-01-01	318926	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-01-01	318926	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	956778	30.0%
2	637852	20.0%
-	637852	20.0%
1	637852	20.0%
3	318926	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2551408	80.0%
Dash Punctuation	637852	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	956778	37.5%
2	637852	25.0%
1	637852	25.0%
3	318926	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	637852	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3189260	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	956778	30.0%
2	637852	20.0%
-	637852	20.0%
1	637852	20.0%
3	318926	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3189260	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	956778	30.0%
2	637852	20.0%
-	637852	20.0%
1	637852	20.0%
3	318926	10.0%

JAAR
Date

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

Minimum	2012-01-01 00:00:00
Maximum	2022-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=11)

BEHANDELEND_SPECIALISME_CD
Real number (ℝ)

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	437.6308

Minimum	301
Maximum	8418
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	301
5-th percentile	302
Q1	305
median	313
Q3	322
95-th percentile	335
Maximum	8418
Range	8117
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	986.98774
Coefficient of variation (CV)	2.2552977
Kurtosis	61.271343
Mean	437.6308
Median Absolute Deviation (MAD)	8
Skewness	7.9487585
Sum	1.3957184 × 10⁸
Variance	974144.79
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
305	45051	14.1%
313	41353	13.0%
303	36720	11.5%
330	25240	7.9%
316	21706	6.8%
308	17147	5.4%
306	13380	4.2%
324	13159	4.1%
301	12804	4.0%
304	10371	3.3%
Other values (18)	81995	25.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
301	12804	4.0%
302	6991	2.2%
303	36720	11.5%
304	10371	3.3%
305	45051	14.1%
306	13380	4.2%
307	5573	1.7%
308	17147	5.4%
310	3496	1.1%
313	41353	13.0%

Value	Count	Frequency (%)
8418	4253	1.3%
8416	543	0.2%
1900	210	0.1%
390	862	0.3%
389	3363	1.1%
362	4301	1.3%
361	2289	0.7%
335	3227	1.0%
330	25240	7.9%
329	834	0.3%

TYPERENDE_DIAGNOSE_CD
Categorical

Distinct	1897
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

101	1347
402	1306
403	1278
301	1275
201	1202
Other values (1892)	312518

Length

Max length	4
Median length	3
Mean length	3.3522479
Min length	2

Characters and Unicode

Total characters	1069119
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	< 0.1%

Sample

1st row	07
2nd row	14
3rd row	03
4th row	17
5th row	01

Common Values

Value	Count	Frequency (%)
101	1347	0.4%
402	1306	0.4%
403	1278	0.4%
301	1275	0.4%
201	1202	0.4%
203	1193	0.4%
401	1067	0.3%
404	1057	0.3%
802	1039	0.3%
409	1030	0.3%
Other values (1887)	307132	96.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
101	1347	0.4%
402	1306	0.4%
403	1278	0.4%
301	1275	0.4%
201	1202	0.4%
203	1193	0.4%
401	1067	0.3%
404	1057	0.3%
802	1039	0.3%
409	1030	0.3%
Other values (1887)	307132	96.3%

Most occurring characters

Value	Count	Frequency (%)
1	204571	19.1%
0	195938	18.3%
2	141707	13.3%
3	115848	10.8%
5	82478	7.7%
9	77055	7.2%
4	75865	7.1%
7	62932	5.9%
6	55871	5.2%
8	46039	4.3%
Other values (15)	10815	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1058304	99.0%
Uppercase Letter	10815	1.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	2017	18.7%
M	1830	16.9%
B	1300	12.0%
E	910	8.4%
Z	902	8.3%
D	725	6.7%
A	703	6.5%
F	674	6.2%
C	357	3.3%
K	350	3.2%
Other values (5)	1047	9.7%

Decimal Number

Value	Count	Frequency (%)
1	204571	19.3%
0	195938	18.5%
2	141707	13.4%
3	115848	10.9%
5	82478	7.8%
9	77055	7.3%
4	75865	7.2%
7	62932	5.9%
6	55871	5.3%
8	46039	4.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	1058304	99.0%
Latin	10815	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	2017	18.7%
M	1830	16.9%
B	1300	12.0%
E	910	8.4%
Z	902	8.3%
D	725	6.7%
A	703	6.5%
F	674	6.2%
C	357	3.3%
K	350	3.2%
Other values (5)	1047	9.7%

Common

Value	Count	Frequency (%)
1	204571	19.3%
0	195938	18.5%
2	141707	13.4%
3	115848	10.9%
5	82478	7.8%
9	77055	7.3%
4	75865	7.2%
7	62932	5.9%
6	55871	5.3%
8	46039	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1069119	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	204571	19.1%
0	195938	18.3%
2	141707	13.3%
3	115848	10.8%
5	82478	7.7%
9	77055	7.2%
4	75865	7.1%
7	62932	5.9%
6	55871	5.2%
8	46039	4.3%
Other values (15)	10815	1.0%

ZORGPRODUCT_CD
Real number (ℝ)

Distinct	6011
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4167032 × 10⁸

Minimum	10501002
Maximum	9.9841808 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	10501002
5-th percentile	28999038
Q1	99799068
median	1.4959903 × 10⁸
Q3	9.90004 × 10⁸
95-th percentile	9.9051604 × 10⁸
Maximum	9.9841808 × 10⁸
Range	9.8791708 × 10⁸
Interquartile range (IQR)	8.9020494 × 10⁸

Descriptive statistics

Standard deviation	4.2921687 × 10⁸
Coefficient of variation (CV)	0.97180375
Kurtosis	-1.7415168
Mean	4.4167032 × 10⁸
Median Absolute Deviation (MAD)	1.1970002 × 10⁸
Skewness	0.46328001
Sum	1.4086015 × 10¹⁴
Variance	1.8422712 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
990004009	2321	0.7%
990004007	2284	0.7%
990003004	2233	0.7%
990004006	1857	0.6%
990356076	1689	0.5%
990356073	1559	0.5%
131999228	1485	0.5%
131999164	1473	0.5%
990003007	1458	0.5%
131999194	1349	0.4%
Other values (6001)	301218	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10501002	9	< 0.1%
10501003	11	< 0.1%
10501004	11	< 0.1%
10501005	11	< 0.1%
10501007	3	< 0.1%
10501008	11	< 0.1%
10501010	11	< 0.1%
10501011	3	< 0.1%
11101002	10	< 0.1%
11101003	11	< 0.1%

Value	Count	Frequency (%)
998418081	160	0.1%
998418080	145	< 0.1%
998418079	38	< 0.1%
998418077	8	< 0.1%
998418076	8	< 0.1%
998418075	6	< 0.1%
998418074	214	0.1%
998418073	214	0.1%
998418072	8	< 0.1%
998418071	8	< 0.1%

AANTAL_PAT_PER_ZPD
Real number (ℝ)

Distinct	10070
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	515.47549

Minimum	1
Maximum	165142
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	14
Q3	104
95-th percentile	1753
Maximum	165142
Range	165141
Interquartile range (IQR)	101

Descriptive statistics

Standard deviation	3174.6685
Coefficient of variation (CV)	6.1587187
Kurtosis	404.01663
Mean	515.47549
Median Absolute Deviation (MAD)	13
Skewness	16.643127
Sum	1.6439854 × 10⁸
Variance	10078520
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	52528	16.5%
2	25677	8.1%
3	16790	5.3%
4	12347	3.9%
5	9613	3.0%
6	8124	2.5%
7	6771	2.1%
8	5742	1.8%
9	5205	1.6%
10	4720	1.5%
Other values (10060)	171409	53.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	52528	16.5%
2	25677	8.1%
3	16790	5.3%
4	12347	3.9%
5	9613	3.0%
6	8124	2.5%
7	6771	2.1%
8	5742	1.8%
9	5205	1.6%
10	4720	1.5%

Value	Count	Frequency (%)
165142	1	< 0.1%
156984	1	< 0.1%
155884	1	< 0.1%
154269	1	< 0.1%
154185	1	< 0.1%
144724	1	< 0.1%
118397	1	< 0.1%
115938	1	< 0.1%
110606	1	< 0.1%
110520	1	< 0.1%

AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	10744
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	608.76077

Minimum	1
Maximum	239709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	15
Q3	114
95-th percentile	1997
Maximum	239709
Range	239708
Interquartile range (IQR)	111

Descriptive statistics

Standard deviation	4082.7328
Coefficient of variation (CV)	6.7066294
Kurtosis	722.57756
Mean	608.76077
Median Absolute Deviation (MAD)	14
Skewness	21.290932
Sum	1.9414964 × 10⁸
Variance	16668707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	50593	15.9%
2	25228	7.9%
3	16626	5.2%
4	12140	3.8%
5	9511	3.0%
6	8123	2.5%
7	6724	2.1%
8	5695	1.8%
9	5135	1.6%
10	4715	1.5%
Other values (10734)	174436	54.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	50593	15.9%
2	25228	7.9%
3	16626	5.2%
4	12140	3.8%
5	9511	3.0%
6	8123	2.5%
7	6724	2.1%
8	5695	1.8%
9	5135	1.6%
10	4715	1.5%

Value	Count	Frequency (%)
239709	1	< 0.1%
232466	1	< 0.1%
231983	1	< 0.1%
230952	1	< 0.1%
227936	1	< 0.1%
227457	1	< 0.1%
225982	1	< 0.1%
223938	1	< 0.1%
218449	1	< 0.1%
215070	1	< 0.1%

AANTAL_PAT_PER_DIAG
Real number (ℝ)

Distinct	8960
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7725.6066

Minimum	1
Maximum	227968
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	42
Q1	411
median	1736
Q3	6417
95-th percentile	36952
Maximum	227968
Range	227967
Interquartile range (IQR)	6006

Descriptive statistics

Standard deviation	17860.004
Coefficient of variation (CV)	2.3117931
Kurtosis	34.156965
Mean	7725.6066
Median Absolute Deviation (MAD)	1577
Skewness	5.0595106
Sum	2.4638968 × 10⁹
Variance	3.1897975 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	529	0.2%
12	482	0.2%
25	475	0.1%
8	465	0.1%
17	451	0.1%
9	450	0.1%
37	448	0.1%
28	430	0.1%
22	429	0.1%
14	425	0.1%
Other values (8950)	314342	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	353	0.1%
2	408	0.1%
3	396	0.1%
4	409	0.1%
5	367	0.1%
6	411	0.1%
7	375	0.1%
8	465	0.1%
9	450	0.1%
10	373	0.1%

Value	Count	Frequency (%)
227968	23	< 0.1%
224643	23	< 0.1%
217853	24	< 0.1%
214514	17	< 0.1%
213536	25	< 0.1%
211593	17	< 0.1%
210434	19	< 0.1%
205348	17	< 0.1%
200603	16	< 0.1%
198527	20	< 0.1%

AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)

Distinct	10035
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11122.475

Minimum	1
Maximum	369838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	53
Q1	547
median	2401
Q3	9151
95-th percentile	52146
Maximum	369838
Range	369837
Interquartile range (IQR)	8604

Descriptive statistics

Standard deviation	26617.827
Coefficient of variation (CV)	2.3931568
Kurtosis	37.888792
Mean	11122.475
Median Absolute Deviation (MAD)	2200
Skewness	5.3149377
Sum	3.5472465 × 10⁹
Variance	7.0850869 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7	367	0.1%
23	351	0.1%
17	348	0.1%
13	346	0.1%
11	342	0.1%
40	341	0.1%
25	341	0.1%
24	340	0.1%
52	339	0.1%
5	338	0.1%
Other values (10025)	315473	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	280	0.1%
2	312	0.1%
3	325	0.1%
4	308	0.1%
5	338	0.1%
6	334	0.1%
7	367	0.1%
8	266	0.1%
9	255	0.1%
10	309	0.1%

Value	Count	Frequency (%)
369838	23	< 0.1%
352154	23	< 0.1%
348523	25	< 0.1%
343082	24	< 0.1%
341692	19	< 0.1%
323791	20	< 0.1%
315783	17	< 0.1%
310778	17	< 0.1%
298646	17	< 0.1%
289045	16	< 0.1%

AANTAL_PAT_PER_SPC
Real number (ℝ)

Distinct	296
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	673592.38

Minimum	1610
Maximum	1487640
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1610
5-th percentile	42576
Q1	288775
median	746967
Q3	1026558
95-th percentile	1340822
Maximum	1487640
Range	1486030
Interquartile range (IQR)	737783

Descriptive statistics

Standard deviation	411429.82
Coefficient of variation (CV)	0.6107994
Kurtosis	-1.0984928
Mean	673592.38
Median Absolute Deviation (MAD)	314315
Skewness	0.0040716922
Sum	2.1482612 × 10¹¹
Variance	1.6927449 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
880941	5102	1.6%
874118	4354	1.4%
843980	4347	1.4%
894334	4333	1.4%
880496	4273	1.3%
897718	4212	1.3%
764865	4088	1.3%
784849	4002	1.3%
1081338	3890	1.2%
1100486	3866	1.2%
Other values (286)	276459	86.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1610	130	< 0.1%
1702	138	< 0.1%
1716	131	< 0.1%
1920	131	< 0.1%
2260	183	0.1%
2495	173	0.1%
6806	380	0.1%
9635	74	< 0.1%
14465	384	0.1%
14969	481	0.2%

Value	Count	Frequency (%)
1487640	2975	0.9%
1450407	3048	1.0%
1421741	3564	1.1%
1344533	3543	1.1%
1340822	3441	1.1%
1332449	3545	1.1%
1316660	3463	1.1%
1282958	3576	1.1%
1265248	1177	0.4%
1262542	1201	0.4%

AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)

Distinct	297
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1085881.9

Minimum	1861
Maximum	2666060
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1861
5-th percentile	47348
Q1	491301
median	1106901
Q3	1756673
95-th percentile	2549839
Maximum	2666060
Range	2664199
Interquartile range (IQR)	1265372

Descriptive statistics

Standard deviation	737059.47
Coefficient of variation (CV)	0.67876576
Kurtosis	-0.77451377
Mean	1085881.9
Median Absolute Deviation (MAD)	621238
Skewness	0.36928889
Sum	3.4631598 × 10¹¹
Variance	5.4325666 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1211791	5102	1.6%
1281518	4354	1.4%
1216262	4347	1.4%
1315601	4333	1.4%
1300468	4273	1.3%
1341881	4212	1.3%
1155430	4088	1.3%
1171476	4002	1.3%
2549839	3890	1.2%
2666060	3866	1.2%
Other values (287)	276459	86.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1861	130	< 0.1%
1961	138	< 0.1%
1981	131	< 0.1%
2195	131	< 0.1%
2816	173	0.1%
3012	183	0.1%
7385	380	0.1%
10290	74	< 0.1%
16683	384	0.1%
17333	481	0.2%

Value	Count	Frequency (%)
2666060	3866	1.2%
2620465	3787	1.2%
2599704	3788	1.2%
2595180	3844	1.2%
2549839	3890	1.2%
2481560	3851	1.2%
2179643	3757	1.2%
2062159	3810	1.2%
2052304	1168	0.4%
1990242	1167	0.4%

GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)

Distinct	3519
Distinct (%)	1.3%
Missing	48866
Missing (%)	15.3%
Infinite	0
Infinite (%)	0.0%
Mean	3563.1378

Minimum	70
Maximum	287220
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	70
5-th percentile	140
Q1	475
median	1250
Q3	4145
95-th percentile	13455
Maximum	287220
Range	287150
Interquartile range (IQR)	3670

Descriptive statistics

Standard deviation	6512.3789
Coefficient of variation (CV)	1.827709
Kurtosis	148.50978
Mean	3563.1378
Median Absolute Deviation (MAD)	1020
Skewness	7.2550817
Sum	9.62261 × 10⁸
Variance	42411079
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
160	2003	0.6%
110	1874	0.6%
105	1839	0.6%
180	1578	0.5%
185	1481	0.5%
145	1380	0.4%
300	1373	0.4%
175	1373	0.4%
120	1335	0.4%
125	1247	0.4%
Other values (3509)	254577	79.8%
(Missing)	48866	15.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
70	226	0.1%
75	75	< 0.1%
80	362	0.1%
85	919	0.3%
90	689	0.2%
95	695	0.2%
100	923	0.3%
105	1839	0.6%
110	1874	0.6%
115	1018	0.3%

Value	Count	Frequency (%)
287220	8	< 0.1%
148910	3	< 0.1%
142835	4	< 0.1%
122155	4	< 0.1%
116765	3	< 0.1%
109725	7	< 0.1%
108570	7	< 0.1%
107655	4	< 0.1%
101270	8	< 0.1%
96880	5	< 0.1%

Auto

Heatmap
Table

	BEHANDELEND_SPECIALISME_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
BEHANDELEND_SPECIALISME_CD	1.000	0.218	0.008	0.013	-0.060	-0.054	-0.547	-0.470	0.050
ZORGPRODUCT_CD	0.218	1.000	-0.141	-0.150	-0.179	-0.211	-0.379	-0.409	0.026
AANTAL_PAT_PER_ZPD	0.008	-0.141	1.000	0.996	0.324	0.322	0.074	0.082	-0.302
AANTAL_SUBTRAJECT_PER_ZPD	0.013	-0.150	0.996	1.000	0.320	0.322	0.077	0.089	-0.305
AANTAL_PAT_PER_DIAG	-0.060	-0.179	0.324	0.320	1.000	0.988	0.321	0.300	0.025
AANTAL_SUBTRAJECT_PER_DIAG	-0.054	-0.211	0.322	0.322	0.988	1.000	0.336	0.331	0.033
AANTAL_PAT_PER_SPC	-0.547	-0.379	0.074	0.077	0.321	0.336	1.000	0.963	-0.014
AANTAL_SUBTRAJECT_PER_SPC	-0.470	-0.409	0.082	0.089	0.300	0.331	0.963	1.000	-0.016
GEMIDDELDE_VERKOOPPRIJS	0.050	0.026	-0.302	-0.305	0.025	0.033	-0.014	-0.016	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
0	1.0	2023-01-06	2023-01-01	2018-01-01	329	07	990029010	227	234	1439	1500	21981	24168	1345.0
1	1.0	2023-01-06	2023-01-01	2018-01-01	329	14	990029010	4	4	97	97	21981	24168	1345.0
2	1.0	2023-01-06	2023-01-01	2018-01-01	329	03	990029011	375	379	847	863	21981	24168	545.0
3	1.0	2023-01-06	2023-01-01	2018-01-01	329	17	990029010	73	73	695	704	21981	24168	1345.0
4	1.0	2023-01-06	2023-01-01	2018-01-01	329	01	990029010	53	54	331	348	21981	24168	1345.0
5	1.0	2023-01-06	2023-01-01	2018-01-01	329	02	990029011	1375	1386	4872	4977	21981	24168	545.0
6	1.0	2023-01-06	2023-01-01	2018-01-01	329	05	990029010	256	261	1285	1346	21981	24168	1345.0
7	1.0	2023-01-06	2023-01-01	2018-01-01	329	13	990029002	6	6	156	157	21981	24168	205.0
8	1.0	2023-01-06	2023-01-01	2018-01-01	329	05	990029002	120	124	1285	1346	21981	24168	205.0
9	1.0	2023-01-06	2023-01-01	2018-01-01	329	16	990029002	161	176	1077	1196	21981	24168	205.0

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
318916	1.0	2023-01-06	2023-01-01	2013-01-01	313	419	990003004	3	3	992	1081	1026558	1974856	100.0
318917	1.0	2023-01-06	2023-01-01	2017-01-01	324	403	131999040	4	9	1221	1467	286441	496620	1140.0
318918	1.0	2023-01-06	2023-01-01	2013-01-01	313	206	49899012	4	4	7705	9805	1026558	1974856	5440.0
318919	1.0	2023-01-06	2023-01-01	2013-01-01	313	773	28999058	6	6	236	1290	1026558	1974856	3180.0
318920	1.0	2023-01-06	2023-01-01	2013-01-01	313	621	29099074	1	2	191	588	1026558	1974856	NaN
318921	1.0	2023-01-06	2023-01-01	2013-01-01	313	924	119499065	1	1	2611	2988	1026558	1974856	2695.0
318922	1.0	2023-01-06	2023-01-01	2013-01-01	313	453	990003004	3	3	408	454	1026558	1974856	100.0
318923	1.0	2023-01-06	2023-01-01	2013-01-01	313	917	119999012	2	2	328	372	1026558	1974856	1620.0
318924	1.0	2023-01-06	2023-01-01	2017-01-01	324	703	69499020	1	1	339	367	286441	496620	NaN
318925	1.0	2023-01-06	2023-01-01	2013-01-01	313	751	979003015	1	1	4485	9034	1026558	1974856	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample